Tabela PhP4TimeTable

Definicja tabeli PhP4TimeTable

Name

PhP4TimeTable

Code

PhP4TimeTable

Comment

tabela harmonogramów do ZSMOPL


Lista kolumn tabeli PhP4TimeTable

Name

Code

TimeTableID

TimeTableID

ScheduledDT

ScheduledDT

TimeTableNo

TimeTableNo

FromDt

FromDt

ToDt

ToDt

Active

Active

HospitalCode

HospitalCode

TimeTableStatusID

TimeTableStatusID

TimeTableTypeID

TimeTableTypeID


Kolumna TimeTableID tabeli PhP4TimeTable

Definicja kolumny TimeTableID tabeli PhP4TimeTable

Name

TimeTableID

Code

TimeTableID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID tabeli harmonogramów do ZSMOPL


Kolumna ScheduledDT tabeli PhP4TimeTable

Definicja kolumny ScheduledDT tabeli PhP4TimeTable

Name

ScheduledDT

Code

ScheduledDT

Data Type

DATE

Mandatory

Yes

Comment

data/godzina zaplanowanego uruchomienia


Kolumna TimeTableNo tabeli PhP4TimeTable

Definicja kolumny TimeTableNo tabeli PhP4TimeTable

Name

TimeTableNo

Code

TimeTableNo

Data Type

VARCHAR2(16)

Mandatory

Yes

Comment

numer harmonogramu


Kolumna FromDt tabeli PhP4TimeTable

Definicja kolumny FromDt tabeli PhP4TimeTable

Name

FromDt

Code

FromDt

Data Type

DATE

Mandatory

No

Comment

data od wysylki komunikatów


Kolumna ToDt tabeli PhP4TimeTable

Definicja kolumny ToDt tabeli PhP4TimeTable

Name

ToDt

Code

ToDt

Data Type

DATE

Mandatory

No

Comment

data do wysylki komunikatów


Kolumna Active tabeli PhP4TimeTable

Definicja kolumny Active tabeli PhP4TimeTable

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Aktywnosc


Kolumna HospitalCode tabeli PhP4TimeTable

Definicja kolumny HospitalCode tabeli PhP4TimeTable

Name

HospitalCode

Code

HospitalCode

Data Type

VARCHAR2(13)

Mandatory

No

Comment

kod szpitala


Kolumna TimeTableStatusID tabeli PhP4TimeTable

Definicja kolumny TimeTableStatusID tabeli PhP4TimeTable

Name

TimeTableStatusID

Code

TimeTableStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID statusu harmonogramu


Kolumna TimeTableTypeID tabeli PhP4TimeTable

Definicja kolumny TimeTableTypeID tabeli PhP4TimeTable

Name

TimeTableTypeID

Code

TimeTableTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID typu harmonogramu


Lista kluczy tabeli PhP4TimeTable

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhP4TimeTable

Definicja klucza Identifier_1 tabeli PhP4TimeTable

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment